Table Joining Activity
(Family)

NOTE:
It is possible to have a relationship between entities of the same type, for example a parent-child relationship is a relationship between two people.

You are asked to design a database for tracking ancestry.
Information about a person would include:
ID, birth date, name at birth (at a minimum)
[Often county of birth, death date, county of death, other names, are tracked as well.]

The parent child relationship is of course to be tracked.
Create a parent child relationship table.
Most people have two parents, but consider adoptive, birth, foster parenting.

The spouse/significant other relationship is to be tracked.
Information about a relationship should include:
Type of relationship (marriage, domestic partner, etc.)
Date relationship began
If relationship terminated, date of termination

At a minimum, design queries to determine:
Children of a given person
Parents of a given person
Siblings of a given person.